{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Control","AUX2","Net42","Net41","Net32","Net31","Net22","Net21","Net12","Net11","AUX","specs"],"not_rendered":{"charts":0,"images":553,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Control","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AUX2","index":1,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":true,"merged":[[3,15,3,16],[47,0,51,17],[20,0,20,1]]}
[{"$f":"'Net42'!B1+'Net41'!B1+'Net32'!B1+'Net31'!B1+'Net22'!B1+'Net21'!B1+'Net12'!B1+'Net11'!B1+SUM(A7:A18)","v":0},"Vtriac(vba)",1.5,{"$f":"+'Net11'!D1+'Net12'!D1+'Net21'!D1+'Net22'!D1+'Net31'!D1+'Net32'!D1+'Net41'!D1+'Net42'!D1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V0",1]
[null,null,{"$f":"+C5*1","v":60},null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,null,null,"V01",2]
[null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,null,null,"V02",3]
[null,null,null,"V","m","i temp","i","drop","k","dist","L","cable","Vinput",1E-4,null,null,null,null,null,null,"V03",4]
["PS - Imax Vout",15,"60","V","-","A","A","V","-","m","km",null,"V","accuracy",null,null,null,null,null,null,"V04",5]
["Vmin amp.",44,{"$f":"IF(C2=60,66,90)","v":66},60,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N7:N14))","v":0},null,null,null,null,null,null,"I01",6]
[{"$f":"IF(D7<0,1,0)","v":0},7,11,{"$f":"+D15-H7","v":60},1,{"$f":"+'Net11'!D2","v":0},{"$f":"+F7*E7","v":0},{"$f":"+G7*K7*VLOOKUP(L7,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J7,(J7*0.3048))/1000*I7","v":0},"cable",60,{"$f":"E7*(+M7-D7)","v":0},null,null,null,null,null,null,"I02",7]
[0,8,12,{"$f":"+D15-H8","v":60},1,{"$f":"+'Net12'!D2","v":0},{"$f":"+F8*E8","v":0},{"$f":"+G8*K8*VLOOKUP(L8,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J8,(J8*0.3048))/1000*I8","v":0},"cable",60,{"$f":"E8*(+M8-D8)","v":0},null,null,null,null,null,null,"I03",8]
[0,9,21,{"$f":"+D16-H9","v":60},1,{"$f":"+'Net21'!D2","v":0},0,{"$f":"+G9*K9*VLOOKUP(L9,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"I04",9]
[0,10,22,{"$f":"+D16-H10","v":60},1,{"$f":"+'Net22'!D2","v":0},0,{"$f":"+G10*K10*VLOOKUP(L10,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"V11",10]
[0,11,31,{"$f":"+D17-H11","v":60},1,{"$f":"+'Net31'!D2","v":0},0,{"$f":"+G11*K11*VLOOKUP(L11,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"V12",11]
[0,12,32,{"$f":"+D17-H12","v":60},1,{"$f":"+'Net32'!D2","v":0},0,{"$f":"+G12*K12*VLOOKUP(L12,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"V21",12]
[0,13,41,{"$f":"+D18-H13","v":60},1,{"$f":"+'Net41'!D2","v":0},0,{"$f":"+G13*K13*VLOOKUP(L13,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"V22",13]
[0,14,42,{"$f":"+D18-H14","v":60},1,{"$f":"+'Net42'!D2","v":0},0,{"$f":"+G14*K14*VLOOKUP(L14,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60,0,null,null,null,null,null,null,"V31",14]
[{"$f":"IF(D15<0,1,0)","v":0},15,"01",{"$f":"+D16-H15","v":60},1,{"$f":"SUM(F7:F8)","v":0},{"$f":"+F15*E15","v":0},{"$f":"+G15*K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J15,(J15*0.3048))/1000*I15","v":0},"cable",{"$f":"K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,null,null,"V32",15]
[{"$f":"IF(D16<0,1,0)","v":0},16,"02",{"$f":"+D17-H16","v":60},1,{"$f":"SUM(F7:F10)","v":0},{"$f":"+F16*E16","v":0},{"$f":"+G16*K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J16,(J16*0.3048))/1000*I16","v":0},"cable",{"$f":"K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,null,null,"V41",16]
[{"$f":"IF(D17<0,1,0)","v":0},17,"03",{"$f":"+D18-H17","v":60},1,{"$f":"SUM(F7:F12)","v":0},{"$f":"+F17*E17","v":0},{"$f":"+G17*K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J17,(J17*0.3048))/1000*I17","v":0},"cable",{"$f":"K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,null,null,"V42",17]
[{"$f":"IF(D18<0,1,0)","v":0},18,"04",{"$f":"+D6-H18","v":60},1,{"$f":"SUM(F7:F14)","v":0},{"$f":"+F18*E18","v":0},{"$f":"+G18*K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J18,(J18*0.3048))/1000*I18","v":0},"cable",{"$f":"K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,null,null,"I11",18]
[null,null,null,null,null,null,null,"D6:L18",null,null,null,null,null,null,null,null,null,null,null,null,"I12",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I21",20]
["Updated Feb.2012",null,"Booster Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I22",21]
["calc. data",null,"calc. data","calc. data","calc. data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I31",22]
["Vin","Ranges","Mcont","TrEff","Bgain","Vout","Pin","Iin","Final Gain ","Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,null,null,"I32",23]
[65,"56.6-66",1,97,1.016,{"$f":"A24*E24/C24-1.5","v":64.540000000000006},{"$f":"M24+L24+K24","v":204.74428013634954},{"$f":"G24/A24","v":3.1499120020976852},{"$f":"F24/A24","v":0.99292307692307702},{"$f":"M24/G24","v":0.97682826532106248},{"$f":"N24*1.5","v":4.6482801363495501},{"$f":"M24*(E24-1)*0.03","v":9.6000000000000085E-2},200,{"$f":"M24/F24","v":3.0988534242330337},null,null,null,null,null,null,"I41",24]
[56.5,"48.3-56.6",1.0249999999999999,96.8,1.1639999999999999,{"$f":"A25*E25/C25-1.5","v":62.66195121951219},{"$f":"M25+L25+K25","v":205.83719429225343},{"$f":"G25/A25","v":3.6431361821637775},{"$f":"F25/A25","v":1.1090610835311892},{"$f":"M25/G25","v":0.97164169326965455},{"$f":"N25*1.5","v":4.7875942922534396},{"$f":"M25*(E25-1)*0.032","v":1.0495999999999994},200,{"$f":"M25/F25","v":3.1917295281689597},null,null,null,null,null,null,"I42",25]
[48.1,"41.4-48.3",1.0249999999999999,96.5,1.37,{"$f":"A26*E26/C26-1.5","v":62.789756097560982},{"$f":"M26+L26+K26","v":207.36784942393896},{"$f":"G26/A26","v":4.3111819007055914},{"$f":"F26/A26","v":1.3054003346686274},{"$f":"M26/G26","v":0.96446966371881371},{"$f":"N26*1.5","v":4.7778494239389673},{"$f":"M26*(E26-1)*0.035","v":2.5900000000000012},200,{"$f":"M26/F26","v":3.185232949292645},null,null,null,null,null,null,"Vend11",26]
[41.3,"30.0-41.4",1.0249999999999999,96.3,1.609,{"$f":"A27*E27/C27-1.5","v":63.330926829268293},{"$f":"M27+L27+K27","v":209.00002209994116},{"$f":"G27/A27","v":5.060533222758866},{"$f":"F27/A27","v":1.5334364849701767},{"$f":"M27/G27","v":0.95693769785518268},{"$f":"N27*1.5","v":4.7370220999411528},{"$f":"M27*(E27-1)*0.035","v":4.2629999999999999},200,{"$f":"M27/F27","v":3.158014733294102},null,null,null,null,null,null,"Vend12",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vend21",28]
["Vin",null,null,null,null,"Vout","Pin","Iin","Final Gain ","Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,null,null,"Vend22",29]
[87,"78.1-90.0",1,97,1.012,{"$f":"A30*E30/C30-1.5","v":86.543999999999997},{"$f":"M30+L30+K30","v":203.53844481419856},{"$f":"G30/A30","v":2.3395223541861903},{"$f":"F30/A30","v":0.99475862068965515},{"$f":"M30/G30","v":0.98261534906868009},{"$f":"N30*1.5","v":3.466444814198558},{"$f":"M30*(E30-1)*0.03","v":7.2000000000000064E-2},200,{"$f":"M30/F30","v":2.3109632094657053},null,null,null,null,null,null,"Vend31",30]
[78,"67.5-78.1",1.0249999999999999,96.8,1.1659999999999999,{"$f":"A31*E31/C31-1.5","v":87.22975609756098},{"$f":"M31+L31+K31","v":204.50159338332745},{"$f":"G31/A31","v":2.6218152997862494},{"$f":"F31/A31","v":1.1183302063789868},{"$f":"M31/G31","v":0.97798748993173146},{"$f":"N31*1.5","v":3.4391933833274608},{"$f":"M31*(E31-1)*0.032","v":1.0623999999999996},200,{"$f":"M31/F31","v":2.292795588884974},null,null,null,null,null,null,"Vend32",31]
[67.400000000000006,"58.5-67.5",1.0249999999999999,96.5,1.3520000000000001,{"$f":"A32*E32/C32-1.5","v":87.402243902439039},{"$f":"M32+L32+K32","v":205.89640615578324},{"$f":"G32/A32","v":3.0548428213024219},{"$f":"F32/A32","v":1.2967691973655642},{"$f":"M32/G32","v":0.97136226772544076},{"$f":"N32*1.5","v":3.4324061557832408},{"$f":"M32*(E32-1)*0.035","v":2.4640000000000009},200,{"$f":"M32/F32","v":2.2882707705221605},null,null,null,null,null,null,"Vend41",32]
[58.4,"40.0-58.5",1.0249999999999999,96.3,1.5569999999999999,{"$f":"A33*E33/C33-1.5","v":87.211024390243907},{"$f":"M33+L33+K33","v":207.33893207392666},{"$f":"G33/A33","v":3.5503241793480593},{"$f":"F33/A33","v":1.4933394587370532},{"$f":"M33/G33","v":0.96460417732203829},{"$f":"N33*1.5","v":3.4399320739266575},{"$f":"M33*(E33-1)*0.035","v":3.899},200,{"$f":"M33/F33","v":2.2932880492844383},null,null,null,null,null,null,"Vend42",33]
["Pin = Pout + Ptriac + Pdelta-transformer, where",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PBVin",34]
["Pin =  Vin x Iin;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PBVout",35]
["Pout =  Vout x Iout;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PBcurin",36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PBcurout",37]
["Ptriac = Vtriac * Iout  , where   Vtriac=1.5V;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bgain",38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STitleLocation",39]
["Pdelta-transformer = (100 - K) / 100 * (n – 1)  *  Pout  , where  K=96.5%  for range\"1.32\" , K=96.8% for range \"1.2\" and K=97% for range \"1\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sTitleVin",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sTitleVout",41]
["Then, assuming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STitleIin",42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sTitleIout",43]
["Vout = Vin * n / Mcont  –  Vtriac ,  where Mcont = 1 for range\"1\", Mcont=1.025 for other two ranges;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sTitleGain",44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",45]
["We get  finally the booster input current Iin, derived from above, as a function of the booster output current Iout and the booster input voltage Vin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntext",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc",47]
["Iin = Iout * n / Mcont * {1+(1 - K / 100) * (n – 1) * [ 1 – Vtriac / (Vout + Vtriac)]}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum",48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc04",49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum04",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc03",51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum03",52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc02",53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum02",54]

{"sheet":"Net42","index":2,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M14","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net42"]

{"sheet":"Net41","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M13","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net41"]

{"sheet":"Net32","index":4,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"'AUX2'!M12","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net32"]

{"sheet":"Net31","index":5,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M11","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net31"]

{"sheet":"Net22","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M10","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net22"]

{"sheet":"Net21","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M9","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net21"]

{"sheet":"Net12","index":8,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M8","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,60]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net12"]

{"sheet":"Net11","index":9,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M7","v":60},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60},{"$f":"G6+G5*G4","v":60},60,60,60,60,60,60,60,{"$f":"O6+O5*O4","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60},{"$f":"G9+G8*G7","v":60},60,60,60,60,60,60,60,{"$f":"O9+O8*O7","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60},{"$f":"G12+G11*G10","v":60},60,60,60,60,60,60,60,{"$f":"O12+O11*O10","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60},{"$f":"G15+G14*G13","v":60},60,60,60,60,60,60,60,{"$f":"O15+O14*O13","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60},{"$f":"G18+G17*G16","v":60},60,60,60,60,60,60,60,{"$f":"O18+O17*O16","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60},{"$f":"G21+G20*G19","v":60},60,60,60,60,60,60,60,{"$f":"O21+O20*O19","v":60}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60},{"$f":"F21-(F3-$B$2)","v":60},60,60,60,60,60,60,60,60]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":60}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net11"]

{"sheet":"AUX","index":10,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,3,1,5],[1,7,1,9]]}
[]
[null,null,null,"R,Ohm",null,null,null,"Vdrop,V"]
[null,"length,m","I,A",540,860,750,"3x10",540,860,750,"3x10","amp type","Inom,A","Vnom,V","Pnom,W","factor_i","cable","loop_res",null,null,null,null,null,null,null,null,"LIST"]
[1,null,null,{"$f":"B4*$R$4","v":0},{"$f":"B4*$R$5","v":0},{"$f":"B4*$R$6","v":0},{"$f":"+B4*$R$7","v":0},{"$f":"$C4*D4","v":0},{"$f":"$C4*E4","v":0},{"$f":"$C4*F4","v":0},{"$f":"$C4*G4","v":0},"HLN",1.4,60,84,{"$f":"M4/(O4/N4)","v":1},"QR540",{"$f":"S4/1000","v":5.28E-3},5.28,"C500",{"$f":"V4/1000","v":5.64E-3},5.64,null,null,null,null,"Net11"]
[2,null,null,0,0,0,{"$f":"+B5*$R$7","v":0},{"$f":"$C5*D5","v":0},{"$f":"$C5*E5","v":0},{"$f":"$C5*F5","v":0},{"$f":"$C5*G5","v":0},"TNA",1,60,60,{"$f":"M5/(O5/N5)","v":1},"QR860",{"$f":"S5/1000","v":2.3700000000000001E-3},2.37,"C625",{"$f":"V5/1000","v":3.6099999999999999E-3},3.61,null,null,null,null,"Net12"]
[3,null,null,0,0,0,{"$f":"+B6*$R$7","v":0},0,0,0,0,"LEX",0.5,60,36,{"$f":"M6/(O6/N6)","v":0.83333333333333337},"C750",{"$f":"S6/1000","v":2.49E-3},2.4900000000000002,null,null,null,null,null,null,null,"Net21"]
[4,null,null,0,0,0,0,0,0,0,0,"DBLE",0.6,60,24,{"$f":"M7/(O7/N7)","v":1.4999999999999998},"3x10",{"$f":"+S7/1000","v":2.5000000000000001E-3},2.5,null,null,null,null,null,null,null,"Net22"]
[5,null,null,0,0,0,0,{"$f":"$C8*D8","v":0},{"$f":"$C8*E8","v":0},0,0,"GNA",1,60,60,{"$f":"M8/(O8/N8)","v":1},"C500",{"$f":"S8/1000","v":5.64E-3},5.64,null,null,null,null,null,null,null,"Net31"]
[6,null,null,0,0,0,0,{"$f":"$C9*D9","v":0},{"$f":"$C9*E9","v":0},0,0,null,null,null,null,null,"C625",3.6099999999999999E-3,3.61,null,null,null,null,null,null,null,"Net32"]
[7,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x10",3.6600000000000001E-3,3.66,null,null,null,null,null,null,null,"Net41"]
[8,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x6",6.0000000000000001E-3,6,null,null,null,null,null,null,null,"Net42"]
[9,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x10",1.83E-3,1.83]
[10,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x6",3.0000000000000001E-3,3]

{"sheet":"specs","index":11,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[19,10,20,13],[21,3,21,4],[21,5,21,6]]}
[]
[]
[null,null,null,1,2,3,4,5,null,null,1,2]
[null,null,"amp type","sorted","Inom,A","Vnom,V","Pnom,W",null,"original","cable","sorted","loop_res",null,null,"original"]
[null,null,"load","DBLE",null,60,30,1,30,"cable","2x10",3.66,"cable",1,3.66]
[null,null,"HLN","future1",null,60,0,1,0,"QR860","2x6",6,"QR860",2,6]
[null,null,"TNA","future2",null,60,0,1,0,"C750","3x10",2.5,"C750",3,2.5]
[null,null,"GNA","future3",null,60,0,1,0,"QR715 ","4x10",1.83,"QR715 ",4,1.83]
[null,null,"LEX","future4",null,60,0,1,0,"C625","4x6",3,"C625",5,3]
[null,null,"DBLE","future5",null,60,0,1,0,"C565 ","C500",5.64,"C565 ",6,5.64]
[null,null,"future1","future6",null,60,0,1,0,"QR540","C565 ",4.26,"QR540",7,4.26]
[null,null,"future2","future7",null,60,0,1,0,"C500","C625",3.61,"C500",8,3.61]
[null,null,"future3","GNA",null,60,48,1,48,"QR1125","C750",2.4900000000000002,"QR1125",9,2.4900000000000002]
[null,null,"future4","HLN",null,60,84,1,84,"3x10","cable",0,"2x10",10,0]
[null,null,"future5","LEX",null,60,26,1,24,"4x10","QR1125",11,"2x6",11,1.3]
[null,null,"future6","load",null,1,0,0,0,"2x10","QR540",5.28,"3x10",12,5.28]
[null,null,"future7","TNA",null,60,52,1,52,"2x6","QR715 ",3.27,"4x10",13,3.27]
[null,null,null,null,null,null,null,null,null,"4x6","QR860",2.37,"4x6",14,2.37]
[null,null,null,null,null,"Range $D$5:$H$17",null,null,null,"type","spare",0,null,null,0]
[]
[]
[null,null,null,"Efficiency",null,"tangens alpha",null,null,null,null,"Range $K$5:$L$19",null,"Cable \ntype","ρ (Ω/Km)"]
[null,null,"Load,%","Super2M-90","T-former","Super2M-90","T-former","load span","SpanN",null,null,null,"QR-540 ",5.28]
[null,"L0",4,36.55806621,62.083720929999998,{"$f":"(D25-D24)/($C25-$C24)","v":4.2606763124999993},{"$f":"+(E25-E24)/($C25-$C24)","v":3.4893378800000008},{"$f":"+C25-C24","v":4},1,null,null,null,"QR-715 ",3.27]
[null,"L1",8,53.600771459999997,76.041072450000001,{"$f":"(D26-D25)/($C26-$C25)","v":2.4445559925000016},1.5768140174999985,{"$f":"+C26-C25","v":4},2,null,null,null,"QR-860 ",2.37]
[null,"L2",12,63.378995430000003,82.348328519999995,1.4451867049999993,0.7958163650000003,8,3,null,null,null,"P3-500 ",5.64]
[null,"L3",20,74.940489069999998,88.714859439999998,0.7155390490000002,0.27130518400000059,10,4,null,null,null,"P3-565 ",4.26]
[null,"L4",30,82.09587956,91.427911280000004,0.48487377400000042,0.12942325799999993,10,5,null,null,null,"P3-625 ",3.61]
[null,"L5",40,86.944617300000004,92.722143860000003,0.17963340999999958,0.11173976900000042,10,6]
[null,"L6",50,88.7409514,93.839541550000007,0.11277000900000048,3.6879177999999513E-2,10,7]
[null,"L7",60,89.868651490000005,94.208333330000002,8.9180478000000105E-2,3.8966666999999691E-2,10,8]
[null,"L8",70,90.760456270000006,94.597999999999999,5.1471151999999167E-2,-5.6377240000003324E-3,10,9]
[null,"L9",80,91.275167789999998,94.541622759999996,4.0063600000053159E-4,-3.8172269999999744E-2,10,10]
[null,"L10",90,91.279174150000003,94.159900059999998,3.6039225000000383E-2,-8.7130945999999196E-2,10,11]
[null,"L11",100,91.639566400000007,93.288590600000006]